CREATE EXTERNAL TABLE `jms_dim`.`dim_tms_main_delivery_network_base_dt_new`(
`id` bigint COMMENT '主键',
`line_id` bigint COMMENT '干线id',
`line_code` string COMMENT '支线编码',
`line_name` string COMMENT '支线名称',
`start_id` bigint COMMENT '始发网点id',
`start_code` string COMMENT '始发网点编号',
`start_name` string COMMENT '始发网点名称',
`end_id` bigint COMMENT '目的网点id',
`end_code` string COMMENT '目的网点编号',
`end_name` string COMMENT '目的网点名称',
`roadsection_code` string COMMENT '路段编码',
`delivery_networklist` string COMMENT '配载网点',
`create_by` bigint COMMENT '创建人id',
`create_by_name` string COMMENT '创建人姓名',
`create_time` timestamp COMMENT '创建时间',
`update_by` bigint COMMENT '更新人id',
`update_by_name` string COMMENT '更新人姓名',
`update_time` timestamp COMMENT '更新时间',
`delivery_reserve_networklist` string COMMENT '备用配载网点',
`trans_code` string COMMENT '主用配载全选的父节点',
`show_code` string COMMENT '主用配载网点显示',
`trans_reserve_code` string COMMENT '备用配载全选的父节点',
`show_reserve_code` string COMMENT '备用配载网点显示',
`exclude_main_network_code` string COMMENT '排除主用的网点编码，多个用英文逗号隔开(系统)',
`exclude_reserve_network_code` string COMMENT '排除备用的网点编码，多个用英文逗号隔开',
`show_two_code` string COMMENT '主2展示(系统)',
`show_main_two_hand_code` string COMMENT '主用2展示节点(手动)',
`main_hand_delivery` string COMMENT '主用手动维护配载',
`reserve_hand_delivery` string COMMENT '备用手动维护配载',
`main_two_hand_delivery` string COMMENT '主用2手动维护配载',
`delivery_two_networklist` string COMMENT '主2配载新信息(系统)',
`trans_two_code` string COMMENT '主2全选父节点(系统)',
`exclude_two_network_code` string COMMENT '排除主2的网点编码，多个用英文逗号隔开(系统)',
`delivery_out_networklist` string COMMENT '兜底配载新信息(系统)',
`trans_out_code` string COMMENT '兜底全选父节点(系统)',
`show_out_code` string COMMENT '兜底展示(系统)',
`exclude_out_network_code` string COMMENT '排除兜底的网点编码，多个用英文逗号隔开(系统)',
`trans_main_hand_code` string COMMENT '主用全选父节点(手动)',
`trans_reserve_hand_code` string COMMENT '备用全选父节点(手动)',
`trans_main_two_hand_code` string COMMENT '主用2全选父节点(手动)',
`show_main_hand_code` string COMMENT '主用展示节点(手动)',
`show_reserve_hand_code` string COMMENT '备用展示节点(手动)')
COMMENT '干线配载网点表'
partitioned by (dt string comment '分区时间')
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION 'hdfs://yl-bg-hdp/dw/hive/jms_dim.db/external/dim_tms_main_delivery_network_base_dt_new'
TBLPROPERTIES (
  'bucketing_version' = '2',
  'transient_lastDdlTime' = '1661916083',
  'last_modified_time' = '1661495388',
  'last_modified_by' = 'hive',
  'parquet.column.index.access' = 'true',
  'discover.partitions' = 'false'
)